// MySheet.h: interface for the CMySheet class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYSHEET_H__2FE02074_BF81_46E0_AA78_99B00E2FDE76__INCLUDED_)
#define AFX_MYSHEET_H__2FE02074_BF81_46E0_AA78_99B00E2FDE76__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include "excel.h"

class CMySheet  
{
public:
	CMySheet();
	virtual ~CMySheet();

public:
	BOOL Initialize(LPCTSTR lpszFileName=NULL);
	

	Worksheets* GetWorkSheets();

	void OpenExcel(LPCTSTR lpszFileName);
	void CloseExcel();
	
	void SaveExcel(LPCTSTR lpszFileName);

	
	void Close();


private:
	_Application	m_appExel;
	Workbooks		m_wbsMyBooks;
	_Workbook		m_wbMyBook;
	Worksheets		m_wssMysheets;

	CString			m_strTemplate; // template file name
	BOOL			m_bSave;
};

#endif // !defined(AFX_MYSHEET_H__2FE02074_BF81_46E0_AA78_99B00E2FDE76__INCLUDED_)
